
package edu.tongji.jiaowu.dao;

import java.math.BigDecimal;
import java.util.List;

import com.tongji.quickCRUDQ.model.CommonBean;
import com.tongji.quickCRUDQ.dao.BaseDao;

public interface ScoreDao extends BaseDao {
	
	public CommonBean createScore();
	
/*
	public CommonBean findScores(String refid) ;
*/
  public CommonBean findScoreById(String id);
	public CommonBean findAllScores() ;
	public void insertScore(CommonBean scoreBean);
	public void updateScore(CommonBean scoreBean);
	public CommonBean findScore(String courseNo, String studentNo);
	public List findStudentScoreSemester(String studentNo);
	public List findStudentScore(String studentNo,String schoolYear,String schoolSemester);
	public BigDecimal findGradePoint(String studentNo,String schoolYear,String schoolSemester);
	public BigDecimal findGradePoint(String studentNo);

	public BigDecimal findSumCredit(String studentNo);

	public BigDecimal findPassedCredit(String studentNo);

	public int findFailedCourseCount(String studentNo);

	public void deleteScore(List deleteScore);

	public void maskScorePrint(String studentNo);

	public void maskScorePrint(String grade, String majorNo);

	public void deleteFailElective();
}

